package com.da.boot.bean;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import com.alibaba.excel.annotation.write.style.HeadStyle;

import lombok.Data;

/**
 * @author JokerDa.
 * @date 2021/7/1 20:02
 * Description:
 */
@Data
@HeadRowHeight(25)
@HeadStyle(fillForegroundColor = 22)
public class TraxSummaryExcelExport {
    @ExcelProperty(value = "事业部", index = 0)
    @ColumnWidth(15)
    private String bu;
    @ExcelProperty(value = "销售大区", index = 1)
    @ColumnWidth(15)
    private String region;
    @ExcelProperty(value = "销售地区", index = 2)
    @ColumnWidth(15)
    private String area;
    @ExcelProperty(value = "渠道", index = 3)
    @ColumnWidth(15)
    private String channelName;
    @ExcelProperty(value = "业态", index = 4)
    @ColumnWidth(15)
    private String formatName;
    @ExcelProperty(value = "售点总数", index = 5)
    @ColumnWidth(15)
    private int totalOfCustomers;
    @ExcelProperty(value = {"分销数", "进口酒"}, index = 6)
    @ColumnWidth(12)
    private int totalOfImportsItemNum;
    @ExcelProperty(value = {"分销数", "国产酒"}, index = 7)
    @ColumnWidth(12)
    private int totalOfNotImportsItemNum;
    @ExcelProperty(value = {"必备SKU分销率", "区域必备SKU分销率"}, index = 8)
    @ColumnWidth(25)
    private String coreItemRate;
    @ExcelProperty(value = {"必备SKU分销率", "全国必备SKU分销率"}, index = 9)
    @ColumnWidth(25)
    private String regularItemRate;
    @ExcelProperty(value = "货架占有率", index = 10)
    @ColumnWidth(15)
    private String goodsShelvesRate;
    @ExcelProperty(value = "地堆占有率", index = 11)
    @ColumnWidth(15)
    private String heapRate;
    @ExcelProperty(value = "冰柜占有率", index = 12)
    @ColumnWidth(15)
    private String freezerRate;
    @ExcelProperty(value = "总占有率", index = 13)
    @ColumnWidth(15)
    private String totalRate;
}
